class CreateFriendships < ActiveRecord::Migration
  def self.up
    create_table :friendships do |t|
      t.integer :member_id
      t.integer :friend_id
      t.integer :status, :default => 0
    end
    add_index :friendships, :member_id, :name=>"fk_member_friendship"
    add_index :friendships, :friend_id, :name=>"fk_friend_friendship"
  end

  def self.down
    drop_table :friendships
  end
end
